{
 "cells": [
  {
   "cell_type": "markdown",
   "metadata": {
    "slideshow": {
     "slide_type": "-"
    }
   },
   "source": [
    "# 导入包"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 1,
   "metadata": {
    "ExecuteTime": {
     "end_time": "2019-07-13T08:51:56.519992Z",
     "start_time": "2019-07-13T08:51:45.873640Z"
    }
   },
   "outputs": [],
   "source": [
    "import requests\n",
    "import simplejson as json\n",
    "import re\n",
    "from bs4 import BeautifulSoup\n",
    "import time\n",
    "import pandas as pd\n",
    "from pandas import DataFrame, Series\n",
    "import random"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {
    "heading_collapsed": true
   },
   "source": [
    "# 网页数据探索"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 2,
   "metadata": {
    "ExecuteTime": {
     "end_time": "2019-05-08T04:16:21.345965Z",
     "start_time": "2019-05-08T04:16:20.869681Z"
    },
    "hidden": true
   },
   "outputs": [],
   "source": [
    "url = 'http://www.91dict.com/words?w=limb'\n",
    "wb_data = requests.get(url)\n",
    "soup = BeautifulSoup(wb_data.text, 'lxml')\n",
    "sheet = soup.select('#imgMainbox')\n",
    "#print(soup)\n",
    "#print(sheet)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 57,
   "metadata": {
    "ExecuteTime": {
     "end_time": "2019-05-01T06:58:14.720009Z",
     "start_time": "2019-05-01T06:58:14.708034Z"
    },
    "hidden": true
   },
   "outputs": [
    {
     "data": {
      "text/plain": [
       "'https://img.91dict.com/img2/ea997f18af034e0a4cbd1e91ca73d7e1/210.jpg?x-oss-process=image/resize,m_fill,h_494,w_800&auth_key=1556928000-0-0-4bc84cfaa1ee56a61953f09634edb5ec'"
      ]
     },
     "execution_count": 57,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "soup.select('#flexslider_2 > ul.slides.clearfix > li:nth-child(1) > div.imgMainbox > img')[0]['src']"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 35,
   "metadata": {
    "ExecuteTime": {
     "end_time": "2019-05-01T05:36:01.567588Z",
     "start_time": "2019-05-01T05:36:01.551630Z"
    },
    "hidden": true
   },
   "outputs": [
    {
     "data": {
      "text/plain": [
       "\"\\nShe'd be more likely to tear you limb from limb.\""
      ]
     },
     "execution_count": 35,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "soup.select('#flexslider_2 > ul.slides.clearfix > li:nth-child(1) > div.imgMainbox > div > div.mBottom')[0].get_text()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 37,
   "metadata": {
    "ExecuteTime": {
     "end_time": "2019-05-01T05:36:48.178355Z",
     "start_time": "2019-05-01T05:36:48.162399Z"
    },
    "hidden": true
   },
   "outputs": [
    {
     "data": {
      "text/plain": [
       "'\\n见到你就会把你五马分尸'"
      ]
     },
     "execution_count": 37,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "soup.select(\"#flexslider_2 > ul.slides.clearfix > li:nth-child(1) > div.imgMainbox > div > div.mFoot\")[0].get_text()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 39,
   "metadata": {
    "ExecuteTime": {
     "end_time": "2019-05-01T05:40:05.944244Z",
     "start_time": "2019-05-01T05:40:05.933357Z"
    },
    "hidden": true
   },
   "outputs": [
    {
     "data": {
      "text/plain": [
       "'https://mp3.91dict.com/mp32/ea997f18af034e0a4cbd1e91ca73d7e1/210.mp3?auth_key=1556928000-0-0-3140ec3241eff5693430fa86c4df5362'"
      ]
     },
     "execution_count": 39,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "soup.select('#flexslider_2 > ul.slides.clearfix > li:nth-child(1) > div.imgMainbox > div > div.mTop > audio')[0]['src']"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 40,
   "metadata": {
    "ExecuteTime": {
     "end_time": "2019-05-01T05:44:45.723108Z",
     "start_time": "2019-05-01T05:44:45.715594Z"
    },
    "hidden": true
   },
   "outputs": [],
   "source": [
    "def save_img(url, title ):\n",
    "    with open('{}.jpg'.format(title), 'wb') as f:\n",
    "        img = requests.get(url).content\n",
    "        f.write(img)\n",
    "        \n",
    "def save_audio(url, title ):\n",
    "    with open('{}.mp3'.format(title), 'wb') as f:\n",
    "        img = requests.get(url).content\n",
    "        f.write(img)"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "# 载入数据"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {
    "heading_collapsed": true
   },
   "source": [
    "## 载入单词列表数据"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 3,
   "metadata": {
    "ExecuteTime": {
     "end_time": "2019-07-13T08:52:52.003795Z",
     "start_time": "2019-07-13T08:52:51.906945Z"
    },
    "hidden": true,
    "scrolled": true
   },
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>0</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>arrogant</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>address</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>account for</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>exaggerated</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>temptation</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>temperamental</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>slum</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>unsuitable</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>insult</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>shrewd</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10</th>\n",
       "      <td>component</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11</th>\n",
       "      <td>perception</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12</th>\n",
       "      <td>glamorous</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13</th>\n",
       "      <td>ample</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14</th>\n",
       "      <td>hinder</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>15</th>\n",
       "      <td>vocal cords</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>16</th>\n",
       "      <td>be sheltered from</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17</th>\n",
       "      <td>peer</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18</th>\n",
       "      <td>grossly</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>19</th>\n",
       "      <td>pension</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>20</th>\n",
       "      <td>stereotype</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21</th>\n",
       "      <td>be superior to</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22</th>\n",
       "      <td>be inferior to</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>23</th>\n",
       "      <td>receipt</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>24</th>\n",
       "      <td>recession</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>25</th>\n",
       "      <td>inflexible</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>26</th>\n",
       "      <td>insurance policy</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>27</th>\n",
       "      <td>subsidy</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>28</th>\n",
       "      <td>downsize</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>29</th>\n",
       "      <td>demanding</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>74</th>\n",
       "      <td>facilitate</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>75</th>\n",
       "      <td>dump</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>76</th>\n",
       "      <td>penalty</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>77</th>\n",
       "      <td>edible</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>78</th>\n",
       "      <td>annual</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>79</th>\n",
       "      <td>legislation</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>80</th>\n",
       "      <td>launch</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>81</th>\n",
       "      <td>worship</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>82</th>\n",
       "      <td>conflict</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>83</th>\n",
       "      <td>apply to</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>84</th>\n",
       "      <td>underrepresented</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>85</th>\n",
       "      <td>amuse</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>86</th>\n",
       "      <td>retailer</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>87</th>\n",
       "      <td>prejudice</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>88</th>\n",
       "      <td>ancestor</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>89</th>\n",
       "      <td>emphasis</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>90</th>\n",
       "      <td>ignorance</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>91</th>\n",
       "      <td>wholesale dealer</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>92</th>\n",
       "      <td>rival</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>93</th>\n",
       "      <td>dramatically</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>94</th>\n",
       "      <td>nutrition</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>95</th>\n",
       "      <td>pharmacist</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>96</th>\n",
       "      <td>minority</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>97</th>\n",
       "      <td>nominee</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>98</th>\n",
       "      <td>tendency</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>99</th>\n",
       "      <td>stereotype</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>100</th>\n",
       "      <td>Hispanics</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>101</th>\n",
       "      <td>biased</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>102</th>\n",
       "      <td>alcohol</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>103</th>\n",
       "      <td>ethnic</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>104 rows × 1 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "                     0\n",
       "0             arrogant\n",
       "1              address\n",
       "2          account for\n",
       "3          exaggerated\n",
       "4           temptation\n",
       "5        temperamental\n",
       "6                 slum\n",
       "7           unsuitable\n",
       "8               insult\n",
       "9               shrewd\n",
       "10           component\n",
       "11          perception\n",
       "12           glamorous\n",
       "13               ample\n",
       "14              hinder\n",
       "15         vocal cords\n",
       "16   be sheltered from\n",
       "17                peer\n",
       "18             grossly\n",
       "19             pension\n",
       "20          stereotype\n",
       "21      be superior to\n",
       "22      be inferior to\n",
       "23             receipt\n",
       "24           recession\n",
       "25          inflexible\n",
       "26    insurance policy\n",
       "27             subsidy\n",
       "28            downsize\n",
       "29           demanding\n",
       "..                 ...\n",
       "74          facilitate\n",
       "75                dump\n",
       "76             penalty\n",
       "77              edible\n",
       "78              annual\n",
       "79         legislation\n",
       "80              launch\n",
       "81             worship\n",
       "82            conflict\n",
       "83            apply to\n",
       "84    underrepresented\n",
       "85               amuse\n",
       "86            retailer\n",
       "87           prejudice\n",
       "88            ancestor\n",
       "89            emphasis\n",
       "90           ignorance\n",
       "91    wholesale dealer\n",
       "92               rival\n",
       "93        dramatically\n",
       "94           nutrition\n",
       "95          pharmacist\n",
       "96            minority\n",
       "97             nominee\n",
       "98            tendency\n",
       "99          stereotype\n",
       "100          Hispanics\n",
       "101             biased\n",
       "102            alcohol\n",
       "103             ethnic\n",
       "\n",
       "[104 rows x 1 columns]"
      ]
     },
     "execution_count": 3,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "word_list = DataFrame()\n",
    "\"\"\"for i in range(10,16):\n",
    "    wordlisti = DataFrame()\n",
    "    print('wl{}.xlsx'.format(i))\n",
    "    wordlisti = pd.read_excel('wl{}.xlsx'.format(i), header = None)\n",
    "    word_list = word_list.append(wordlisti, ignore_index=True)\"\"\"\n",
    "wordlist_plus = pd.read_excel('6级1.xlsx', header = None)\n",
    "word_list = word_list.append(wordlist_plus, ignore_index=True)\n",
    "word_list"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {
    "heading_collapsed": true
   },
   "source": [
    "## 载入网页单词数据"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 4,
   "metadata": {
    "ExecuteTime": {
     "end_time": "2019-07-13T08:53:33.480005Z",
     "start_time": "2019-07-13T08:53:33.466201Z"
    },
    "hidden": true
   },
   "outputs": [
    {
     "ename": "FileNotFoundError",
     "evalue": "[Errno 2] No such file or directory: '网页词汇.json'",
     "output_type": "error",
     "traceback": [
      "\u001b[0;31m---------------------------------------------------------------------------\u001b[0m",
      "\u001b[0;31mFileNotFoundError\u001b[0m                         Traceback (most recent call last)",
      "\u001b[0;32m<ipython-input-4-0343df649053>\u001b[0m in \u001b[0;36m<module>\u001b[0;34m\u001b[0m\n\u001b[0;32m----> 1\u001b[0;31m \u001b[0;32mwith\u001b[0m \u001b[0mopen\u001b[0m\u001b[0;34m(\u001b[0m\u001b[0;34m'网页词汇.json'\u001b[0m\u001b[0;34m,\u001b[0m \u001b[0;34m'r'\u001b[0m\u001b[0;34m,\u001b[0m \u001b[0mencoding\u001b[0m\u001b[0;34m=\u001b[0m\u001b[0;34m'UTF-8'\u001b[0m\u001b[0;34m)\u001b[0m \u001b[0;32mas\u001b[0m \u001b[0mf\u001b[0m\u001b[0;34m:\u001b[0m\u001b[0;34m\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n\u001b[0m\u001b[1;32m      2\u001b[0m      \u001b[0mdata\u001b[0m \u001b[0;34m=\u001b[0m \u001b[0mjson\u001b[0m\u001b[0;34m.\u001b[0m\u001b[0mloads\u001b[0m\u001b[0;34m(\u001b[0m\u001b[0mf\u001b[0m\u001b[0;34m.\u001b[0m\u001b[0mread\u001b[0m\u001b[0;34m(\u001b[0m\u001b[0;34m)\u001b[0m\u001b[0;34m)\u001b[0m\u001b[0;34m\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n",
      "\u001b[0;31mFileNotFoundError\u001b[0m: [Errno 2] No such file or directory: '网页词汇.json'"
     ]
    }
   ],
   "source": [
    "with open('网页词汇.json', 'r', encoding='UTF-8') as f:\n",
    "     data = json.loads(f.read())"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 14,
   "metadata": {
    "hidden": true
   },
   "outputs": [],
   "source": [
    "word_list = {}\n",
    "for i in data['notes']:\n",
    "    word_list[i['fields'][0]] = i['fields'][8]"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "# 爬虫"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 5,
   "metadata": {
    "ExecuteTime": {
     "end_time": "2019-07-13T08:53:40.155574Z",
     "start_time": "2019-07-13T08:53:40.145625Z"
    }
   },
   "outputs": [],
   "source": [
    "def dict_91(url):\n",
    "        wb_data = requests.get(url, headers = headers)\n",
    "        soup = BeautifulSoup(wb_data.text, 'lxml')\n",
    "\n",
    "        image_url = soup.select('#flexslider_2 > ul.slides.clearfix > li:nth-child(1) > div.imgMainbox > img')[0]['src']\n",
    "        captian_eng = soup.select('#flexslider_2 > ul.slides.clearfix > li:nth-child(1) > div.imgMainbox > div > div.mBottom')[0].get_text()\n",
    "        captian_chs = soup.select(\"#flexslider_2 > ul.slides.clearfix > li:nth-child(1) > div.imgMainbox > div > div.mFoot\")[0].get_text()\n",
    "        audio_url = soup.select('#flexslider_2 > ul.slides.clearfix > li:nth-child(1) > div.imgMainbox > div > div.mTop > audio')[0]['src']\n",
    "        return [image_url, audio_url, captian_chs, captian_eng]\n",
    "\n",
    "def save_img(url, title):\n",
    "    with open('{}.jpg'.format(title), 'wb') as f:\n",
    "        img = requests.get(url, headers = headers).content\n",
    "        f.write(img)\n",
    "\n",
    "\n",
    "def save_audio(url, title):\n",
    "    with open('{}.mp3'.format(title), 'wb') as f:\n",
    "        img = requests.get(url, headers = headers).content\n",
    "        f.write(img)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 6,
   "metadata": {
    "ExecuteTime": {
     "end_time": "2019-07-13T09:01:07.714765Z",
     "start_time": "2019-07-13T08:53:51.309276Z"
    }
   },
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "1\n",
      "arrogant\n",
      "http://www.91dict.com/words?w=arrogant\n",
      "\n",
      "Arrogant, selfish snobs do not dip themselves in blue paint\n",
      "2\n",
      "address\n",
      "http://www.91dict.com/words?w=address\n",
      "\n",
      "My address? My home is Los Angeles, it's a Los Angeles address.\n",
      "3\n",
      "account for\n",
      "http://www.91dict.com/words?w=account for\n",
      "\n",
      "I don't have to account for my decisions\n",
      "4\n",
      "exaggerated\n",
      "http://www.91dict.com/words?w=exaggerated\n",
      "\n",
      "Praise laid upon your house has not been exaggerated.\n",
      "5\n",
      "temptation\n",
      "http://www.91dict.com/words?w=temptation\n",
      "\n",
      "So, we hang out in public to avoid temptation.\n",
      "6\n",
      "temperamental\n",
      "http://www.91dict.com/words?w=temperamental\n",
      "\n",
      "He's looking. Don't make eye contact. He's kind of temperamental.\n",
      "7\n",
      "slum\n",
      "http://www.91dict.com/words?w=slum\n",
      "\n",
      "in the slum they call \"The Court of Miracles\".\n",
      "8\n",
      "unsuitable\n",
      "http://www.91dict.com/words?w=unsuitable\n",
      "\n",
      "We wholly agree that the existing brochure is unsuitable.\n",
      "9\n",
      "insult\n",
      "http://www.91dict.com/words?w=insult\n",
      "\n",
      "Don't insult my intelligence, and I won't insult yours.\n",
      "10\n",
      "shrewd\n",
      "http://www.91dict.com/words?w=shrewd\n",
      "\n",
      "You are celebrated for your shrewd intelligence, Caiaphas.\n",
      "11\n",
      "component\n",
      "http://www.91dict.com/words?w=component\n",
      "\n",
      "but of course research was a component, massive research.\n",
      "12\n",
      "perception\n",
      "http://www.91dict.com/words?w=perception\n",
      "\n",
      "people's perception of forensic DNA will be shattered.\n",
      "13\n",
      "glamorous\n",
      "http://www.91dict.com/words?w=glamorous\n",
      "\n",
      "Come on, all you need is a big, glamorous party.\n",
      "14\n",
      "ample\n",
      "http://www.91dict.com/words?w=ample\n",
      "\n",
      "I'd like to get my hands on her ample nossels,\n",
      "15\n",
      "hinder\n",
      "http://www.91dict.com/words?w=hinder\n",
      "\n",
      "A woman's presence can only hinder our escape.\n",
      "16\n",
      "vocal cords\n",
      "http://www.91dict.com/words?w=vocal cords\n",
      "\n",
      "hearing starts to go, vocal cords get creaky.\n",
      "17\n",
      "be sheltered from\n",
      "http://www.91dict.com/words?w=be sheltered from\n",
      "18\n",
      "peer\n",
      "http://www.91dict.com/words?w=peer\n",
      "\n",
      "Let me tell you little something about peer pressure.\n",
      "19\n",
      "grossly\n",
      "http://www.91dict.com/words?w=grossly\n",
      "\n",
      "I think the Agency has grossly underestimated you,\n",
      "20\n",
      "pension\n",
      "http://www.91dict.com/words?w=pension\n",
      "\n",
      "I'd have nothing, not even a soldier's pension.\n",
      "21\n",
      "stereotype\n",
      "http://www.91dict.com/words?w=stereotype\n",
      "\n",
      "Is that a stereotype I don't know about?\n",
      "22\n",
      "be superior to\n",
      "http://www.91dict.com/words?w=be superior to\n",
      "\n",
      "might in fact be superior to their own.\n",
      "23\n",
      "be inferior to\n",
      "http://www.91dict.com/words?w=be inferior to\n",
      "\n",
      "but still it would be inferior to Parliament,\n",
      "24\n",
      "receipt\n",
      "http://www.91dict.com/words?w=receipt\n",
      "\n",
      "You know what, I might have the fedex receipt\n",
      "25\n",
      "recession\n",
      "http://www.91dict.com/words?w=recession\n",
      "\n",
      "we are in the middle of a recession.\n",
      "26\n",
      "inflexible\n",
      "http://www.91dict.com/words?w=inflexible\n",
      "\n",
      "that I need to be a little more inflexible.\n",
      "27\n",
      "insurance policy\n",
      "http://www.91dict.com/words?w=insurance policy\n",
      "\n",
      "He had a life insurance policy with us\n",
      "28\n",
      "subsidy\n",
      "http://www.91dict.com/words?w=subsidy\n",
      "\n",
      "And if you vote for me, I can deliver the black caucus for the farm subsidy.\n",
      "29\n",
      "downsize\n",
      "http://www.91dict.com/words?w=downsize\n",
      "\n",
      "Who cares? It's time to downsize, minimize my carbon footprint.\n",
      "30\n",
      "demanding\n",
      "http://www.91dict.com/words?w=demanding\n",
      "\n",
      "Your daughter is still demanding to see you, Mr. President.\n",
      "31\n",
      "basic necessities\n",
      "http://www.91dict.com/words?w=basic necessities\n",
      "32\n",
      "drawback\n",
      "http://www.91dict.com/words?w=drawback\n",
      "\n",
      "Since you don't like him, I don't see that much of a drawback.\n",
      "33\n",
      "mortgage\n",
      "http://www.91dict.com/words?w=mortgage\n",
      "\n",
      "the mortgage on my Parkview Terrace apartment, right?\n",
      "34\n",
      "financial crises\n",
      "http://www.91dict.com/words?w=financial crises\n",
      "35\n",
      "curriculum\n",
      "http://www.91dict.com/words?w=curriculum\n",
      "\n",
      "We've been wanting to incorporate more philosophy into the curriculum,\n",
      "36\n",
      "riot\n",
      "http://www.91dict.com/words?w=riot\n",
      "\n",
      "There's gonna be a riot in DuPont! Riot in Thompkins Square bitches!\n",
      "37\n",
      "hazard\n",
      "http://www.91dict.com/words?w=hazard\n",
      "\n",
      "So you may talk about moral hazard. You are the moral hazard.\n",
      "38\n",
      "perspective\n",
      "http://www.91dict.com/words?w=perspective\n",
      "\n",
      "I have a perspective on the stunted male psyche\n",
      "39\n",
      "admissions office\n",
      "http://www.91dict.com/words?w=admissions office\n",
      "40\n",
      "bureaucracy\n",
      "http://www.91dict.com/words?w=bureaucracy\n",
      "\n",
      "Bureaucracy has a funny way of keeping people together.\n",
      "41\n",
      "wipe out\n",
      "http://www.91dict.com/words?w=wipe out\n",
      "\n",
      "when they wipe out? It's like a weapon.\n",
      "42\n",
      "thrive\n",
      "http://www.91dict.com/words?w=thrive\n",
      "\n",
      "that in order for this institution to thrive,\n",
      "43\n",
      "sympathize\n",
      "http://www.91dict.com/words?w=sympathize\n",
      "\n",
      "I need you to empathize with him. Sympathize.\n",
      "44\n",
      "commercial\n",
      "http://www.91dict.com/words?w=commercial\n",
      "\n",
      "If I say it's a beer commercial, it's a bloody beer commercial.\n",
      "45\n",
      "consensus\n",
      "http://www.91dict.com/words?w=consensus\n",
      "\n",
      "to form a consensus in his own administration.\n",
      "46\n",
      "allowance\n",
      "http://www.91dict.com/words?w=allowance\n",
      "\n",
      "Well, you Beverly Hills kids and your allowance.\n",
      "47\n",
      "deteriorate\n",
      "http://www.91dict.com/words?w=deteriorate\n",
      "\n",
      "The new tissue would never break down, never deteriorate.\n",
      "48\n",
      "adverse effect\n",
      "http://www.91dict.com/words?w=adverse effect\n",
      "49\n",
      "advocate\n",
      "http://www.91dict.com/words?w=advocate\n",
      "\n",
      "Do you advocate the assassination of public officials?\n",
      "50\n",
      "be deficient in\n",
      "http://www.91dict.com/words?w=be deficient in\n",
      "\n",
      "The plants can be deficient in certain things,\n",
      "51\n",
      "be inclined to do\n",
      "http://www.91dict.com/words?w=be inclined to do\n",
      "52\n",
      "benefits package\n",
      "http://www.91dict.com/words?w=benefits package\n",
      "53\n",
      "rescue package\n",
      "http://www.91dict.com/words?w=rescue package\n",
      "54\n",
      "scheme\n",
      "http://www.91dict.com/words?w=scheme\n",
      "\n",
      "were a small part of their much larger scheme.\n",
      "55\n",
      "transition\n",
      "http://www.91dict.com/words?w=transition\n",
      "\n",
      "so I might have to transition to aspiring screenwriter, right?\n",
      "56\n",
      "priority\n",
      "http://www.91dict.com/words?w=priority\n",
      "\n",
      "Chloe, I need to put out a priority APB.\n",
      "57\n",
      "endorse\n",
      "http://www.91dict.com/words?w=endorse\n",
      "\n",
      "Why would the temple not endorse support for his family?\n",
      "58\n",
      "endorsement contracta\n",
      "http://www.91dict.com/words?w=endorsement contracta\n",
      "59\n",
      "alternative\n",
      "http://www.91dict.com/words?w=alternative\n",
      "\n",
      "Please use an alternative method of payment. Card not authorised.\n",
      "60\n",
      "tedious\n",
      "http://www.91dict.com/words?w=tedious\n",
      "\n",
      "Gets a little tedious after all these years, but...\n",
      "61\n",
      "obesity\n",
      "http://www.91dict.com/words?w=obesity\n",
      "\n",
      "It can lead to obesity in children and\n",
      "62\n",
      "complimentary\n",
      "http://www.91dict.com/words?w=complimentary\n",
      "\n",
      "No. I love being treated like a complimentary hotel toothbrush.\n",
      "63\n",
      "complementary\n",
      "http://www.91dict.com/words?w=complementary\n",
      "\n",
      "Complementary delousing once a month. Don't lose your key!\n",
      "64\n",
      "comply with\n",
      "http://www.91dict.com/words?w=comply with\n",
      "\n",
      "That way, they could comply with the lawsuits,\n",
      "65\n",
      "promotion\n",
      "http://www.91dict.com/words?w=promotion\n",
      "\n",
      "- What's this for? -Your promotion. - All right, my promotion!\n",
      "66\n",
      "prohibit\n",
      "http://www.91dict.com/words?w=prohibit\n",
      "\n",
      "The laws of nature prohibit a naked singularity.\n",
      "67\n",
      "pronciple\n",
      "http://www.91dict.com/words?w=pronciple\n",
      "68\n",
      "principal\n",
      "http://www.91dict.com/words?w=principal\n",
      "\n",
      "I get to be Principal Goldenrod's assistant for the day.\n",
      "69\n",
      "eliminate\n",
      "http://www.91dict.com/words?w=eliminate\n",
      "\n",
      "eliminate the next target or they will eliminate me.\n",
      "70\n",
      "impose\n",
      "http://www.91dict.com/words?w=impose\n",
      "\n",
      "But I can't impose on you like this, Constance.\n",
      "71\n",
      "regulation\n",
      "http://www.91dict.com/words?w=regulation\n",
      "\n",
      "for the regulation of these colorful gypsy tribes\n",
      "72\n",
      "aspiration\n",
      "http://www.91dict.com/words?w=aspiration\n",
      "\n",
      "I'll need a bone marrow aspiration to confirm...\n",
      "73\n",
      "surplus\n",
      "http://www.91dict.com/words?w=surplus\n",
      "\n",
      "Well, it's alright. I can pay for the surplus.\n",
      "74\n",
      "morality\n",
      "http://www.91dict.com/words?w=morality\n",
      "\n",
      "But isn't morality relative, considering what's at stake here?\n",
      "75\n",
      "facilitate\n",
      "http://www.91dict.com/words?w=facilitate\n",
      "\n",
      "to see if we could facilitate a military escort.\n",
      "76\n",
      "dump\n",
      "http://www.91dict.com/words?w=dump\n",
      "\n",
      "They're in the dump. Nothing comes back from the dump.\n",
      "77\n",
      "penalty\n",
      "http://www.91dict.com/words?w=penalty\n",
      "\n",
      "And we talk about you avoiding the death penalty.\n",
      "78\n",
      "edible\n",
      "http://www.91dict.com/words?w=edible\n",
      "\n",
      "while eating a whole box of her edible underwear.\n",
      "79\n",
      "annual\n",
      "http://www.91dict.com/words?w=annual\n",
      "\n",
      "And finally, we're gonna have to take your annual salary,\n",
      "80\n",
      "legislation\n",
      "http://www.91dict.com/words?w=legislation\n",
      "\n",
      "spreading misinformation and influencing legislation for your personal gain.\n",
      "81\n",
      "launch\n",
      "http://www.91dict.com/words?w=launch\n",
      "\n",
      "I'll have everything I need to launch Michaela\n"
     ]
    },
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "82\n",
      "worship\n",
      "http://www.91dict.com/words?w=worship\n",
      "\n",
      "\"worship me and I'll treat you like shit.\"\n",
      "83\n",
      "conflict\n",
      "http://www.91dict.com/words?w=conflict\n",
      "\n",
      "Adolescence can be a time of conflict and rebellion.\n",
      "84\n",
      "apply to\n",
      "http://www.91dict.com/words?w=apply to\n",
      "\n",
      "The laws of sanctuary only apply to churches\n",
      "85\n",
      "underrepresented\n",
      "http://www.91dict.com/words?w=underrepresented\n",
      "86\n",
      "amuse\n",
      "http://www.91dict.com/words?w=amuse\n",
      "\n",
      "\"amuse me. \" you should be thanking me for those movies.\n",
      "87\n",
      "retailer\n",
      "http://www.91dict.com/words?w=retailer\n",
      "\n",
      "just owned real estate and Wal-Mart is primarily a retailer.\n",
      "88\n",
      "prejudice\n",
      "http://www.91dict.com/words?w=prejudice\n",
      "\n",
      "I would stimulate your prostate with pride and zero prejudice.\n",
      "89\n",
      "ancestor\n",
      "http://www.91dict.com/words?w=ancestor\n",
      "\n",
      "You know what? I heard about your ancestor.\n",
      "90\n",
      "emphasis\n",
      "http://www.91dict.com/words?w=emphasis\n",
      "\n",
      "World War II puts a lot of emphasis on food.\n",
      "91\n",
      "ignorance\n",
      "http://www.91dict.com/words?w=ignorance\n",
      "\n",
      "Worn out by your entire ignorance of my existence,\n",
      "92\n",
      "wholesale dealer\n",
      "http://www.91dict.com/words?w=wholesale dealer\n",
      "93\n",
      "rival\n",
      "http://www.91dict.com/words?w=rival\n",
      "\n",
      "orchestrated by a major rival to the United States,\n",
      "94\n",
      "dramatically\n",
      "http://www.91dict.com/words?w=dramatically\n",
      "\n",
      "Interesting point dramatically, this guy was an idiot...\n",
      "95\n",
      "nutrition\n",
      "http://www.91dict.com/words?w=nutrition\n",
      "\n",
      "Eat it. You guys need nutrition. Or not.\n",
      "96\n",
      "pharmacist\n",
      "http://www.91dict.com/words?w=pharmacist\n",
      "\n",
      "Hey, dude, do I look like a pharmacist?\n",
      "97\n",
      "minority\n",
      "http://www.91dict.com/words?w=minority\n",
      "\n",
      "And I may be in the minority here,\n",
      "98\n",
      "nominee\n",
      "http://www.91dict.com/words?w=nominee\n",
      "\n",
      "They can't find a nominee that's not a world-class fuck-up.\n",
      "99\n",
      "tendency\n",
      "http://www.91dict.com/words?w=tendency\n",
      "\n",
      "a really annoying tendency to bail last minute\n",
      "100\n",
      "stereotype\n",
      "http://www.91dict.com/words?w=stereotype\n",
      "\n",
      "Is that a stereotype I don't know about?\n",
      "101\n",
      "Hispanics\n",
      "http://www.91dict.com/words?w=Hispanics\n",
      "\n",
      "I'm going to need an RA for two male Hispanics,\n",
      "102\n",
      "biased\n",
      "http://www.91dict.com/words?w=biased\n",
      "\n",
      "Yeah. I mean, I'm biased, but he's very creative.\n",
      "103\n",
      "alcohol\n",
      "http://www.91dict.com/words?w=alcohol\n",
      "\n",
      "for which alcohol was a secondary contributing factor.\n",
      "104\n",
      "ethnic\n",
      "http://www.91dict.com/words?w=ethnic\n",
      "\n",
      "I overheard their ethnic mix is short a token blond.\n"
     ]
    }
   ],
   "source": [
    "url = 'http://www.91dict.com/words?w={}'\n",
    "user_agents = [\n",
    "    'Mozilla/5.0 (Windows NT 10.0; WOW64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/56.0.2924.87 Safari/537.36',\n",
    "    'Mozilla/5.0 (Macintosh; U; Intel Mac OS X 10_6_8; en-us) AppleWebKit/534.50 (KHTML, like Gecko) Version/5.1 Safari/534.50',\n",
    "    'Mozilla/5.0 (Windows; U; Windows NT 6.1; en-us) AppleWebKit/534.50 (KHTML, like Gecko) Version/5.1 Safari/534.50',\n",
    "    'Mozilla/5.0 (Windows NT 10.0; WOW64; rv:38.0) Gecko/20100101 Firefox/38.0',\n",
    "    'Mozilla/5.0 (Windows NT 10.0; WOW64; Trident/7.0; .NET4.0C; .NET4.0E; .NET CLR 2.0.50727; .NET CLR 3.0.30729; .NET CLR 3.5.30729; InfoPath.3; rv:11.0) like Gecko',\n",
    "    'Mozilla/5.0 (Macintosh; Intel Mac OS X 10.6; rv:2.0.1) Gecko/20100101 Firefox/4.0.1',\n",
    "    'Opera/9.80 (Windows NT 6.1; U; en) Presto/2.8.131 Version/11.11',\n",
    "    'Mozilla/4.0 (compatible; MSIE 7.0; Windows NT 5.1; Maxthon 2.0)',\n",
    "    'Mozilla/4.0 (compatible; MSIE 7.0; Windows NT 5.1; 360SE)',\n",
    "    'Mozilla/4.0 (compatible; MSIE 7.0; Windows NT 5.1; Trident/4.0; SE 2.X MetaSr 1.0; SE 2.X MetaSr 1.0; .NET CLR 2.0.50727; SE 2.X MetaSr 1.0)'\n",
    "]\n",
    "\n",
    "times = [1.234, 4.343, 2.435, 3.34, 2.34, 3.342]\n",
    "dataframe = list()\n",
    "j = 1\n",
    "#网页词汇用下面这个for循环\n",
    "#for word in word_list:\n",
    "#词汇列表用下面这个for循环\n",
    "for word in word_list[0]:\n",
    "    print(j)\n",
    "    j = j + 1\n",
    "    print(word)\n",
    "    user_agent = random.choice(user_agents)\n",
    "    query_url = url.format(word)\n",
    "    print(query_url)\n",
    "    headers = {\n",
    "    'user-agent': user_agent\n",
    "    }\n",
    "    time_step = random.choice(times)\n",
    "    time.sleep(time_step)\n",
    "    try:\n",
    "        info_list = dict_91(query_url)\n",
    "        print(info_list[3])\n",
    "        save_img(info_list[0], word)\n",
    "        save_audio(info_list[1], word)\n",
    "        info_list.append(word)\n",
    "        dataframe.append(info_list)\n",
    "    except IndexError as e:\n",
    "        pass\n",
    "    \n",
    "dataframe = DataFrame(dataframe)\n",
    "func = lambda x:x.split('\\n')[1]\n",
    "dataframe[5] = dataframe[2].apply(func)\n",
    "dataframe[6] = dataframe[3].apply(func)\n",
    "del dataframe[0]\n",
    "del dataframe[1]\n",
    "del dataframe[2]\n",
    "del dataframe[3]\n",
    "func_sound = lambda x:'[sound:{}.mp3]'.format(x)\n",
    "func_img = lambda x:'<img src=\"{}.jpg\">'.format(x)\n",
    "dataframe[7] = dataframe[4].apply(func_sound)\n",
    "dataframe[8] = dataframe[4].apply(func_img)\n",
    "dataframe.head()\n",
    "dataframe.to_csv('word_list_yasi_finish.csv', header = None)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 46,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "1\n",
      "1\n",
      "1\n",
      "1\n",
      "1\n",
      "1\n",
      "1\n",
      "1\n",
      "1\n",
      "1\n",
      "1\n",
      "1\n",
      "1\n",
      "1\n",
      "1\n",
      "1\n",
      "1\n",
      "1\n",
      "1\n",
      "1\n",
      "1\n",
      "1\n",
      "1\n",
      "1\n",
      "1\n",
      "1\n",
      "1\n",
      "1\n",
      "1\n",
      "1\n",
      "1\n",
      "1\n",
      "1\n",
      "1\n",
      "1\n",
      "1\n",
      "1\n",
      "1\n",
      "1\n",
      "1\n",
      "1\n",
      "1\n",
      "1\n",
      "1\n",
      "1\n",
      "1\n",
      "1\n",
      "1\n",
      "1\n",
      "1\n",
      "1\n",
      "1\n",
      "1\n",
      "1\n",
      "1\n",
      "1\n",
      "1\n",
      "1\n",
      "1\n",
      "1\n",
      "1\n",
      "1\n",
      "1\n",
      "1\n",
      "1\n",
      "1\n",
      "1\n",
      "1\n",
      "1\n",
      "1\n",
      "1\n",
      "1\n",
      "1\n",
      "1\n",
      "1\n",
      "1\n",
      "1\n",
      "1\n",
      "1\n",
      "1\n",
      "1\n",
      "1\n",
      "1\n",
      "1\n",
      "1\n",
      "1\n",
      "1\n",
      "1\n",
      "1\n",
      "1\n",
      "1\n",
      "1\n",
      "1\n",
      "1\n",
      "1\n",
      "1\n",
      "1\n",
      "1\n",
      "1\n",
      "1\n",
      "1\n",
      "1\n",
      "1\n",
      "1\n",
      "1\n",
      "1\n",
      "1\n",
      "1\n",
      "1\n",
      "1\n",
      "1\n",
      "1\n",
      "1\n",
      "1\n",
      "1\n",
      "1\n",
      "1\n",
      "1\n",
      "1\n",
      "1\n",
      "1\n",
      "1\n",
      "1\n",
      "1\n",
      "1\n",
      "1\n",
      "1\n",
      "1\n",
      "1\n",
      "1\n",
      "1\n",
      "1\n",
      "1\n",
      "1\n",
      "1\n",
      "1\n",
      "1\n",
      "1\n",
      "1\n",
      "1\n",
      "1\n",
      "1\n",
      "1\n",
      "1\n",
      "1\n",
      "1\n",
      "1\n",
      "1\n",
      "1\n",
      "1\n",
      "1\n",
      "1\n",
      "1\n",
      "1\n",
      "1\n",
      "1\n",
      "1\n",
      "1\n",
      "1\n",
      "1\n",
      "1\n",
      "1\n",
      "1\n",
      "1\n",
      "1\n"
     ]
    }
   ],
   "source": [
    "# 注意，这里的声明的字符形式（整数型/浮点型/字符串 etc）和下面一定要一样\n",
    "row[9] = 'adf'\n",
    "# 如何更改row的数据？\n",
    "for index, row in dataframe.iterrows():\n",
    "    dataframe.at[index, 9] = word_list[row[4]]\n",
    "    print(row[9])"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 8,
   "metadata": {
    "ExecuteTime": {
     "end_time": "2019-07-13T09:05:40.636383Z",
     "start_time": "2019-07-13T09:05:40.594617Z"
    }
   },
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>4</th>\n",
       "      <th>5</th>\n",
       "      <th>6</th>\n",
       "      <th>7</th>\n",
       "      <th>8</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>arrogant</td>\n",
       "      <td>傲慢自私的势利小人是不会把自己弄成蓝色</td>\n",
       "      <td>Arrogant, selfish snobs do not dip themselves ...</td>\n",
       "      <td>[sound:arrogant.mp3]</td>\n",
       "      <td>&lt;img src=\"arrogant.jpg\"&gt;</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>address</td>\n",
       "      <td>我的地址吗 我家在洛杉矶 是洛杉矶地址</td>\n",
       "      <td>My address? My home is Los Angeles, it's a Los...</td>\n",
       "      <td>[sound:address.mp3]</td>\n",
       "      <td>&lt;img src=\"address.jpg\"&gt;</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>account for</td>\n",
       "      <td>我没必要向你或任何人</td>\n",
       "      <td>I don't have to account for my decisions</td>\n",
       "      <td>[sound:account for.mp3]</td>\n",
       "      <td>&lt;img src=\"account for.jpg\"&gt;</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>exaggerated</td>\n",
       "      <td>我对你家从来就没有虚夸过</td>\n",
       "      <td>Praise laid upon your house has not been exagg...</td>\n",
       "      <td>[sound:exaggerated.mp3]</td>\n",
       "      <td>&lt;img src=\"exaggerated.jpg\"&gt;</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>temptation</td>\n",
       "      <td>所以只能去公共场合来抵挡诱惑</td>\n",
       "      <td>So, we hang out in public to avoid temptation.</td>\n",
       "      <td>[sound:temptation.mp3]</td>\n",
       "      <td>&lt;img src=\"temptation.jpg\"&gt;</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>temperamental</td>\n",
       "      <td>他在看你 别看着他 他脾气暴躁</td>\n",
       "      <td>He's looking. Don't make eye contact. He's kin...</td>\n",
       "      <td>[sound:temperamental.mp3]</td>\n",
       "      <td>&lt;img src=\"temperamental.jpg\"&gt;</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>slum</td>\n",
       "      <td>在那个名为\"圣迹区\"的贫民窟里死于绝望</td>\n",
       "      <td>in the slum they call \"The Court of Miracles\".</td>\n",
       "      <td>[sound:slum.mp3]</td>\n",
       "      <td>&lt;img src=\"slum.jpg\"&gt;</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>unsuitable</td>\n",
       "      <td>我们完全同意现有的公司简介并不合适</td>\n",
       "      <td>We wholly agree that the existing brochure is ...</td>\n",
       "      <td>[sound:unsuitable.mp3]</td>\n",
       "      <td>&lt;img src=\"unsuitable.jpg\"&gt;</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>insult</td>\n",
       "      <td>别侮辱我的智商 明人不说暗话</td>\n",
       "      <td>Don't insult my intelligence, and I won't insu...</td>\n",
       "      <td>[sound:insult.mp3]</td>\n",
       "      <td>&lt;img src=\"insult.jpg\"&gt;</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>shrewd</td>\n",
       "      <td>你的智慧为世人称赞 该亚法</td>\n",
       "      <td>You are celebrated for your shrewd intelligenc...</td>\n",
       "      <td>[sound:shrewd.mp3]</td>\n",
       "      <td>&lt;img src=\"shrewd.jpg\"&gt;</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10</th>\n",
       "      <td>component</td>\n",
       "      <td>当然研究也不可或缺 大量的研究</td>\n",
       "      <td>but of course research was a component, massiv...</td>\n",
       "      <td>[sound:component.mp3]</td>\n",
       "      <td>&lt;img src=\"component.jpg\"&gt;</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11</th>\n",
       "      <td>perception</td>\n",
       "      <td>会粉碎DNA用于法医鉴定的前景</td>\n",
       "      <td>people's perception of forensic DNA will be sh...</td>\n",
       "      <td>[sound:perception.mp3]</td>\n",
       "      <td>&lt;img src=\"perception.jpg\"&gt;</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12</th>\n",
       "      <td>glamorous</td>\n",
       "      <td>你不就需要一个大派对让你崭露头角嘛</td>\n",
       "      <td>Come on, all you need is a big, glamorous party.</td>\n",
       "      <td>[sound:glamorous.mp3]</td>\n",
       "      <td>&lt;img src=\"glamorous.jpg\"&gt;</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13</th>\n",
       "      <td>ample</td>\n",
       "      <td>我真希望能亲手碰碰她的引擎舱</td>\n",
       "      <td>I'd like to get my hands on her ample nossels,</td>\n",
       "      <td>[sound:ample.mp3]</td>\n",
       "      <td>&lt;img src=\"ample.jpg\"&gt;</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14</th>\n",
       "      <td>hinder</td>\n",
       "      <td>女人只会阻碍我们逃跑的步伐</td>\n",
       "      <td>A woman's presence can only hinder our escape.</td>\n",
       "      <td>[sound:hinder.mp3]</td>\n",
       "      <td>&lt;img src=\"hinder.jpg\"&gt;</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>15</th>\n",
       "      <td>vocal cords</td>\n",
       "      <td>听力就会慢慢退化 声音也会变得嘶哑</td>\n",
       "      <td>hearing starts to go, vocal cords get creaky.</td>\n",
       "      <td>[sound:vocal cords.mp3]</td>\n",
       "      <td>&lt;img src=\"vocal cords.jpg\"&gt;</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>16</th>\n",
       "      <td>peer</td>\n",
       "      <td>让我来告诉你们什么叫做攀比心理</td>\n",
       "      <td>Let me tell you little something about peer pr...</td>\n",
       "      <td>[sound:peer.mp3]</td>\n",
       "      <td>&lt;img src=\"peer.jpg\"&gt;</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17</th>\n",
       "      <td>grossly</td>\n",
       "      <td>我觉得局里太低估你了</td>\n",
       "      <td>I think the Agency has grossly underestimated ...</td>\n",
       "      <td>[sound:grossly.mp3]</td>\n",
       "      <td>&lt;img src=\"grossly.jpg\"&gt;</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18</th>\n",
       "      <td>pension</td>\n",
       "      <td>我将无所依靠 甚至连抚恤金都没有</td>\n",
       "      <td>I'd have nothing, not even a soldier's pension.</td>\n",
       "      <td>[sound:pension.mp3]</td>\n",
       "      <td>&lt;img src=\"pension.jpg\"&gt;</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>19</th>\n",
       "      <td>stereotype</td>\n",
       "      <td>我是不是对他们有所误会了</td>\n",
       "      <td>Is that a stereotype I don't know about?</td>\n",
       "      <td>[sound:stereotype.mp3]</td>\n",
       "      <td>&lt;img src=\"stereotype.jpg\"&gt;</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>20</th>\n",
       "      <td>be superior to</td>\n",
       "      <td>真的要优于自己的文化</td>\n",
       "      <td>might in fact be superior to their own.</td>\n",
       "      <td>[sound:be superior to.mp3]</td>\n",
       "      <td>&lt;img src=\"be superior to.jpg\"&gt;</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21</th>\n",
       "      <td>be inferior to</td>\n",
       "      <td>但它仍旧受英国上下议院管理</td>\n",
       "      <td>but still it would be inferior to Parliament,</td>\n",
       "      <td>[sound:be inferior to.mp3]</td>\n",
       "      <td>&lt;img src=\"be inferior to.jpg\"&gt;</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22</th>\n",
       "      <td>receipt</td>\n",
       "      <td>我的易趣邮箱里可能还有联邦快递的单据</td>\n",
       "      <td>You know what, I might have the fedex receipt</td>\n",
       "      <td>[sound:receipt.mp3]</td>\n",
       "      <td>&lt;img src=\"receipt.jpg\"&gt;</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>23</th>\n",
       "      <td>recession</td>\n",
       "      <td>我们处于经济萧条期</td>\n",
       "      <td>we are in the middle of a recession.</td>\n",
       "      <td>[sound:recession.mp3]</td>\n",
       "      <td>&lt;img src=\"recession.jpg\"&gt;</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>24</th>\n",
       "      <td>inflexible</td>\n",
       "      <td>我得更强硬一点</td>\n",
       "      <td>that I need to be a little more inflexible.</td>\n",
       "      <td>[sound:inflexible.mp3]</td>\n",
       "      <td>&lt;img src=\"inflexible.jpg\"&gt;</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>25</th>\n",
       "      <td>insurance policy</td>\n",
       "      <td>他在我们公司买了人寿保险</td>\n",
       "      <td>He had a life insurance policy with us</td>\n",
       "      <td>[sound:insurance policy.mp3]</td>\n",
       "      <td>&lt;img src=\"insurance policy.jpg\"&gt;</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>26</th>\n",
       "      <td>subsidy</td>\n",
       "      <td>如果你们投票 我就为黑人同盟会争取更多农业补助</td>\n",
       "      <td>And if you vote for me, I can deliver the blac...</td>\n",
       "      <td>[sound:subsidy.mp3]</td>\n",
       "      <td>&lt;img src=\"subsidy.jpg\"&gt;</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>27</th>\n",
       "      <td>downsize</td>\n",
       "      <td>谁在乎 也该节能减排 过低碳生活了</td>\n",
       "      <td>Who cares? It's time to downsize, minimize my ...</td>\n",
       "      <td>[sound:downsize.mp3]</td>\n",
       "      <td>&lt;img src=\"downsize.jpg\"&gt;</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>28</th>\n",
       "      <td>demanding</td>\n",
       "      <td>您的女儿坚持要见您 总统阁下</td>\n",
       "      <td>Your daughter is still demanding to see you, M...</td>\n",
       "      <td>[sound:demanding.mp3]</td>\n",
       "      <td>&lt;img src=\"demanding.jpg\"&gt;</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>29</th>\n",
       "      <td>drawback</td>\n",
       "      <td>你又不喜欢他 我不觉得这有什么不好</td>\n",
       "      <td>Since you don't like him, I don't see that muc...</td>\n",
       "      <td>[sound:drawback.mp3]</td>\n",
       "      <td>&lt;img src=\"drawback.jpg\"&gt;</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>62</th>\n",
       "      <td>surplus</td>\n",
       "      <td>没事 超出的部分我可以自己付</td>\n",
       "      <td>Well, it's alright. I can pay for the surplus.</td>\n",
       "      <td>[sound:surplus.mp3]</td>\n",
       "      <td>&lt;img src=\"surplus.jpg\"&gt;</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>63</th>\n",
       "      <td>morality</td>\n",
       "      <td>但考虑到目前的当务之急 这点不道德算什么呢</td>\n",
       "      <td>But isn't morality relative, considering what'...</td>\n",
       "      <td>[sound:morality.mp3]</td>\n",
       "      <td>&lt;img src=\"morality.jpg\"&gt;</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>64</th>\n",
       "      <td>facilitate</td>\n",
       "      <td>看看能不能安排一支军队护送他</td>\n",
       "      <td>to see if we could facilitate a military escort.</td>\n",
       "      <td>[sound:facilitate.mp3]</td>\n",
       "      <td>&lt;img src=\"facilitate.jpg\"&gt;</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>65</th>\n",
       "      <td>dump</td>\n",
       "      <td>已经进了废弃堆 回不来了</td>\n",
       "      <td>They're in the dump. Nothing comes back from t...</td>\n",
       "      <td>[sound:dump.mp3]</td>\n",
       "      <td>&lt;img src=\"dump.jpg\"&gt;</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>66</th>\n",
       "      <td>penalty</td>\n",
       "      <td>然后我们可以谈谈怎么让你免受死刑</td>\n",
       "      <td>And we talk about you avoiding the death penalty.</td>\n",
       "      <td>[sound:penalty.mp3]</td>\n",
       "      <td>&lt;img src=\"penalty.jpg\"&gt;</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>67</th>\n",
       "      <td>edible</td>\n",
       "      <td>一边吃了一整盒她的可食用内裤</td>\n",
       "      <td>while eating a whole box of her edible underwear.</td>\n",
       "      <td>[sound:edible.mp3]</td>\n",
       "      <td>&lt;img src=\"edible.jpg\"&gt;</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>68</th>\n",
       "      <td>annual</td>\n",
       "      <td>最后 我们要把你的年收入</td>\n",
       "      <td>And finally, we're gonna have to take your ann...</td>\n",
       "      <td>[sound:annual.mp3]</td>\n",
       "      <td>&lt;img src=\"annual.jpg\"&gt;</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>69</th>\n",
       "      <td>legislation</td>\n",
       "      <td>散布虚假信息 控制立法来满足私利</td>\n",
       "      <td>spreading misinformation and influencing legis...</td>\n",
       "      <td>[sound:legislation.mp3]</td>\n",
       "      <td>&lt;img src=\"legislation.jpg\"&gt;</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>70</th>\n",
       "      <td>launch</td>\n",
       "      <td>我就具备了在米凯拉怀孕前</td>\n",
       "      <td>I'll have everything I need to launch Michaela</td>\n",
       "      <td>[sound:launch.mp3]</td>\n",
       "      <td>&lt;img src=\"launch.jpg\"&gt;</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>71</th>\n",
       "      <td>worship</td>\n",
       "      <td>\"你信奉我 我却视你为粪土\"</td>\n",
       "      <td>\"worship me and I'll treat you like shit.\"</td>\n",
       "      <td>[sound:worship.mp3]</td>\n",
       "      <td>&lt;img src=\"worship.jpg\"&gt;</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>72</th>\n",
       "      <td>conflict</td>\n",
       "      <td>青春期确实会出现反抗和叛逆行为</td>\n",
       "      <td>Adolescence can be a time of conflict and rebe...</td>\n",
       "      <td>[sound:conflict.mp3]</td>\n",
       "      <td>&lt;img src=\"conflict.jpg\"&gt;</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>73</th>\n",
       "      <td>apply to</td>\n",
       "      <td>避难所法令只对那些</td>\n",
       "      <td>The laws of sanctuary only apply to churches</td>\n",
       "      <td>[sound:apply to.mp3]</td>\n",
       "      <td>&lt;img src=\"apply to.jpg\"&gt;</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>74</th>\n",
       "      <td>amuse</td>\n",
       "      <td>你逗逗我吧\" 你们真该感谢我拍了那些电影</td>\n",
       "      <td>\"amuse me. \" you should be thanking me for tho...</td>\n",
       "      <td>[sound:amuse.mp3]</td>\n",
       "      <td>&lt;img src=\"amuse.jpg\"&gt;</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>75</th>\n",
       "      <td>retailer</td>\n",
       "      <td>而沃尔玛主要经营零售</td>\n",
       "      <td>just owned real estate and Wal-Mart is primari...</td>\n",
       "      <td>[sound:retailer.mp3]</td>\n",
       "      <td>&lt;img src=\"retailer.jpg\"&gt;</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>76</th>\n",
       "      <td>prejudice</td>\n",
       "      <td>我会非常骄傲而且没有歧视</td>\n",
       "      <td>I would stimulate your prostate with pride and...</td>\n",
       "      <td>[sound:prejudice.mp3]</td>\n",
       "      <td>&lt;img src=\"prejudice.jpg\"&gt;</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>77</th>\n",
       "      <td>ancestor</td>\n",
       "      <td>知道吗 我听说了你祖先的事</td>\n",
       "      <td>You know what? I heard about your ancestor.</td>\n",
       "      <td>[sound:ancestor.mp3]</td>\n",
       "      <td>&lt;img src=\"ancestor.jpg\"&gt;</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>78</th>\n",
       "      <td>emphasis</td>\n",
       "      <td>都很珍惜食物</td>\n",
       "      <td>World War II puts a lot of emphasis on food.</td>\n",
       "      <td>[sound:emphasis.mp3]</td>\n",
       "      <td>&lt;img src=\"emphasis.jpg\"&gt;</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>79</th>\n",
       "      <td>ignorance</td>\n",
       "      <td>受够了你对我熟视无睹</td>\n",
       "      <td>Worn out by your entire ignorance of my existe...</td>\n",
       "      <td>[sound:ignorance.mp3]</td>\n",
       "      <td>&lt;img src=\"ignorance.jpg\"&gt;</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>80</th>\n",
       "      <td>rival</td>\n",
       "      <td>精心策划的一次组织性极强的阴谋</td>\n",
       "      <td>orchestrated by a major rival to the United St...</td>\n",
       "      <td>[sound:rival.mp3]</td>\n",
       "      <td>&lt;img src=\"rival.jpg\"&gt;</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>81</th>\n",
       "      <td>dramatically</td>\n",
       "      <td>有趣的是这家伙是个白痴</td>\n",
       "      <td>Interesting point dramatically, this guy was a...</td>\n",
       "      <td>[sound:dramatically.mp3]</td>\n",
       "      <td>&lt;img src=\"dramatically.jpg\"&gt;</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>82</th>\n",
       "      <td>nutrition</td>\n",
       "      <td>吃了吧 你们需要营养 也许不需要吧</td>\n",
       "      <td>Eat it. You guys need nutrition. Or not.</td>\n",
       "      <td>[sound:nutrition.mp3]</td>\n",
       "      <td>&lt;img src=\"nutrition.jpg\"&gt;</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>83</th>\n",
       "      <td>pharmacist</td>\n",
       "      <td>伙计 我看起来像药剂师吗</td>\n",
       "      <td>Hey, dude, do I look like a pharmacist?</td>\n",
       "      <td>[sound:pharmacist.mp3]</td>\n",
       "      <td>&lt;img src=\"pharmacist.jpg\"&gt;</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>84</th>\n",
       "      <td>minority</td>\n",
       "      <td>或许我不代表多数人的意见</td>\n",
       "      <td>And I may be in the minority here,</td>\n",
       "      <td>[sound:minority.mp3]</td>\n",
       "      <td>&lt;img src=\"minority.jpg\"&gt;</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>85</th>\n",
       "      <td>nominee</td>\n",
       "      <td>找不出一个不是大蠢蛋的当候选人</td>\n",
       "      <td>They can't find a nominee that's not a world-c...</td>\n",
       "      <td>[sound:nominee.mp3]</td>\n",
       "      <td>&lt;img src=\"nominee.jpg\"&gt;</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>86</th>\n",
       "      <td>tendency</td>\n",
       "      <td>总喜欢在基友之夜的</td>\n",
       "      <td>a really annoying tendency to bail last minute</td>\n",
       "      <td>[sound:tendency.mp3]</td>\n",
       "      <td>&lt;img src=\"tendency.jpg\"&gt;</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>87</th>\n",
       "      <td>stereotype</td>\n",
       "      <td>我是不是对他们有所误会了</td>\n",
       "      <td>Is that a stereotype I don't know about?</td>\n",
       "      <td>[sound:stereotype.mp3]</td>\n",
       "      <td>&lt;img src=\"stereotype.jpg\"&gt;</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>88</th>\n",
       "      <td>Hispanics</td>\n",
       "      <td>需要救护</td>\n",
       "      <td>I'm going to need an RA for two male Hispanics,</td>\n",
       "      <td>[sound:Hispanics.mp3]</td>\n",
       "      <td>&lt;img src=\"Hispanics.jpg\"&gt;</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>89</th>\n",
       "      <td>biased</td>\n",
       "      <td>我承认我偏心 他非常有创意</td>\n",
       "      <td>Yeah. I mean, I'm biased, but he's very creative.</td>\n",
       "      <td>[sound:biased.mp3]</td>\n",
       "      <td>&lt;img src=\"biased.jpg\"&gt;</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>90</th>\n",
       "      <td>alcohol</td>\n",
       "      <td>导致每天增加这么多人住院治疗</td>\n",
       "      <td>for which alcohol was a secondary contributing...</td>\n",
       "      <td>[sound:alcohol.mp3]</td>\n",
       "      <td>&lt;img src=\"alcohol.jpg\"&gt;</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>91</th>\n",
       "      <td>ethnic</td>\n",
       "      <td>各种族得均匀 而他们还少个金发白人</td>\n",
       "      <td>I overheard their ethnic mix is short a token ...</td>\n",
       "      <td>[sound:ethnic.mp3]</td>\n",
       "      <td>&lt;img src=\"ethnic.jpg\"&gt;</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>92 rows × 5 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "                   4                        5  \\\n",
       "0           arrogant      傲慢自私的势利小人是不会把自己弄成蓝色   \n",
       "1            address      我的地址吗 我家在洛杉矶 是洛杉矶地址   \n",
       "2        account for               我没必要向你或任何人   \n",
       "3        exaggerated             我对你家从来就没有虚夸过   \n",
       "4         temptation           所以只能去公共场合来抵挡诱惑   \n",
       "5      temperamental          他在看你 别看着他 他脾气暴躁   \n",
       "6               slum      在那个名为\"圣迹区\"的贫民窟里死于绝望   \n",
       "7         unsuitable        我们完全同意现有的公司简介并不合适   \n",
       "8             insult           别侮辱我的智商 明人不说暗话   \n",
       "9             shrewd            你的智慧为世人称赞 该亚法   \n",
       "10         component          当然研究也不可或缺 大量的研究   \n",
       "11        perception          会粉碎DNA用于法医鉴定的前景   \n",
       "12         glamorous        你不就需要一个大派对让你崭露头角嘛   \n",
       "13             ample           我真希望能亲手碰碰她的引擎舱   \n",
       "14            hinder            女人只会阻碍我们逃跑的步伐   \n",
       "15       vocal cords        听力就会慢慢退化 声音也会变得嘶哑   \n",
       "16              peer          让我来告诉你们什么叫做攀比心理   \n",
       "17           grossly               我觉得局里太低估你了   \n",
       "18           pension         我将无所依靠 甚至连抚恤金都没有   \n",
       "19        stereotype             我是不是对他们有所误会了   \n",
       "20    be superior to               真的要优于自己的文化   \n",
       "21    be inferior to            但它仍旧受英国上下议院管理   \n",
       "22           receipt       我的易趣邮箱里可能还有联邦快递的单据   \n",
       "23         recession                我们处于经济萧条期   \n",
       "24        inflexible                  我得更强硬一点   \n",
       "25  insurance policy             他在我们公司买了人寿保险   \n",
       "26           subsidy  如果你们投票 我就为黑人同盟会争取更多农业补助   \n",
       "27          downsize        谁在乎 也该节能减排 过低碳生活了   \n",
       "28         demanding           您的女儿坚持要见您 总统阁下   \n",
       "29          drawback        你又不喜欢他 我不觉得这有什么不好   \n",
       "..               ...                      ...   \n",
       "62           surplus           没事 超出的部分我可以自己付   \n",
       "63          morality    但考虑到目前的当务之急 这点不道德算什么呢   \n",
       "64        facilitate           看看能不能安排一支军队护送他   \n",
       "65              dump             已经进了废弃堆 回不来了   \n",
       "66           penalty         然后我们可以谈谈怎么让你免受死刑   \n",
       "67            edible           一边吃了一整盒她的可食用内裤   \n",
       "68            annual             最后 我们要把你的年收入   \n",
       "69       legislation         散布虚假信息 控制立法来满足私利   \n",
       "70            launch             我就具备了在米凯拉怀孕前   \n",
       "71           worship           \"你信奉我 我却视你为粪土\"   \n",
       "72          conflict          青春期确实会出现反抗和叛逆行为   \n",
       "73          apply to                避难所法令只对那些   \n",
       "74             amuse     你逗逗我吧\" 你们真该感谢我拍了那些电影   \n",
       "75          retailer               而沃尔玛主要经营零售   \n",
       "76         prejudice             我会非常骄傲而且没有歧视   \n",
       "77          ancestor            知道吗 我听说了你祖先的事   \n",
       "78          emphasis                   都很珍惜食物   \n",
       "79         ignorance               受够了你对我熟视无睹   \n",
       "80             rival          精心策划的一次组织性极强的阴谋   \n",
       "81      dramatically              有趣的是这家伙是个白痴   \n",
       "82         nutrition        吃了吧 你们需要营养 也许不需要吧   \n",
       "83        pharmacist             伙计 我看起来像药剂师吗   \n",
       "84          minority             或许我不代表多数人的意见   \n",
       "85           nominee          找不出一个不是大蠢蛋的当候选人   \n",
       "86          tendency                总喜欢在基友之夜的   \n",
       "87        stereotype             我是不是对他们有所误会了   \n",
       "88         Hispanics                     需要救护   \n",
       "89            biased            我承认我偏心 他非常有创意   \n",
       "90           alcohol           导致每天增加这么多人住院治疗   \n",
       "91            ethnic        各种族得均匀 而他们还少个金发白人   \n",
       "\n",
       "                                                    6  \\\n",
       "0   Arrogant, selfish snobs do not dip themselves ...   \n",
       "1   My address? My home is Los Angeles, it's a Los...   \n",
       "2            I don't have to account for my decisions   \n",
       "3   Praise laid upon your house has not been exagg...   \n",
       "4      So, we hang out in public to avoid temptation.   \n",
       "5   He's looking. Don't make eye contact. He's kin...   \n",
       "6      in the slum they call \"The Court of Miracles\".   \n",
       "7   We wholly agree that the existing brochure is ...   \n",
       "8   Don't insult my intelligence, and I won't insu...   \n",
       "9   You are celebrated for your shrewd intelligenc...   \n",
       "10  but of course research was a component, massiv...   \n",
       "11  people's perception of forensic DNA will be sh...   \n",
       "12   Come on, all you need is a big, glamorous party.   \n",
       "13     I'd like to get my hands on her ample nossels,   \n",
       "14     A woman's presence can only hinder our escape.   \n",
       "15      hearing starts to go, vocal cords get creaky.   \n",
       "16  Let me tell you little something about peer pr...   \n",
       "17  I think the Agency has grossly underestimated ...   \n",
       "18    I'd have nothing, not even a soldier's pension.   \n",
       "19           Is that a stereotype I don't know about?   \n",
       "20            might in fact be superior to their own.   \n",
       "21      but still it would be inferior to Parliament,   \n",
       "22      You know what, I might have the fedex receipt   \n",
       "23               we are in the middle of a recession.   \n",
       "24        that I need to be a little more inflexible.   \n",
       "25             He had a life insurance policy with us   \n",
       "26  And if you vote for me, I can deliver the blac...   \n",
       "27  Who cares? It's time to downsize, minimize my ...   \n",
       "28  Your daughter is still demanding to see you, M...   \n",
       "29  Since you don't like him, I don't see that muc...   \n",
       "..                                                ...   \n",
       "62     Well, it's alright. I can pay for the surplus.   \n",
       "63  But isn't morality relative, considering what'...   \n",
       "64   to see if we could facilitate a military escort.   \n",
       "65  They're in the dump. Nothing comes back from t...   \n",
       "66  And we talk about you avoiding the death penalty.   \n",
       "67  while eating a whole box of her edible underwear.   \n",
       "68  And finally, we're gonna have to take your ann...   \n",
       "69  spreading misinformation and influencing legis...   \n",
       "70     I'll have everything I need to launch Michaela   \n",
       "71         \"worship me and I'll treat you like shit.\"   \n",
       "72  Adolescence can be a time of conflict and rebe...   \n",
       "73       The laws of sanctuary only apply to churches   \n",
       "74  \"amuse me. \" you should be thanking me for tho...   \n",
       "75  just owned real estate and Wal-Mart is primari...   \n",
       "76  I would stimulate your prostate with pride and...   \n",
       "77        You know what? I heard about your ancestor.   \n",
       "78       World War II puts a lot of emphasis on food.   \n",
       "79  Worn out by your entire ignorance of my existe...   \n",
       "80  orchestrated by a major rival to the United St...   \n",
       "81  Interesting point dramatically, this guy was a...   \n",
       "82           Eat it. You guys need nutrition. Or not.   \n",
       "83            Hey, dude, do I look like a pharmacist?   \n",
       "84                 And I may be in the minority here,   \n",
       "85  They can't find a nominee that's not a world-c...   \n",
       "86     a really annoying tendency to bail last minute   \n",
       "87           Is that a stereotype I don't know about?   \n",
       "88    I'm going to need an RA for two male Hispanics,   \n",
       "89  Yeah. I mean, I'm biased, but he's very creative.   \n",
       "90  for which alcohol was a secondary contributing...   \n",
       "91  I overheard their ethnic mix is short a token ...   \n",
       "\n",
       "                               7                                 8  \n",
       "0           [sound:arrogant.mp3]          <img src=\"arrogant.jpg\">  \n",
       "1            [sound:address.mp3]           <img src=\"address.jpg\">  \n",
       "2        [sound:account for.mp3]       <img src=\"account for.jpg\">  \n",
       "3        [sound:exaggerated.mp3]       <img src=\"exaggerated.jpg\">  \n",
       "4         [sound:temptation.mp3]        <img src=\"temptation.jpg\">  \n",
       "5      [sound:temperamental.mp3]     <img src=\"temperamental.jpg\">  \n",
       "6               [sound:slum.mp3]              <img src=\"slum.jpg\">  \n",
       "7         [sound:unsuitable.mp3]        <img src=\"unsuitable.jpg\">  \n",
       "8             [sound:insult.mp3]            <img src=\"insult.jpg\">  \n",
       "9             [sound:shrewd.mp3]            <img src=\"shrewd.jpg\">  \n",
       "10         [sound:component.mp3]         <img src=\"component.jpg\">  \n",
       "11        [sound:perception.mp3]        <img src=\"perception.jpg\">  \n",
       "12         [sound:glamorous.mp3]         <img src=\"glamorous.jpg\">  \n",
       "13             [sound:ample.mp3]             <img src=\"ample.jpg\">  \n",
       "14            [sound:hinder.mp3]            <img src=\"hinder.jpg\">  \n",
       "15       [sound:vocal cords.mp3]       <img src=\"vocal cords.jpg\">  \n",
       "16              [sound:peer.mp3]              <img src=\"peer.jpg\">  \n",
       "17           [sound:grossly.mp3]           <img src=\"grossly.jpg\">  \n",
       "18           [sound:pension.mp3]           <img src=\"pension.jpg\">  \n",
       "19        [sound:stereotype.mp3]        <img src=\"stereotype.jpg\">  \n",
       "20    [sound:be superior to.mp3]    <img src=\"be superior to.jpg\">  \n",
       "21    [sound:be inferior to.mp3]    <img src=\"be inferior to.jpg\">  \n",
       "22           [sound:receipt.mp3]           <img src=\"receipt.jpg\">  \n",
       "23         [sound:recession.mp3]         <img src=\"recession.jpg\">  \n",
       "24        [sound:inflexible.mp3]        <img src=\"inflexible.jpg\">  \n",
       "25  [sound:insurance policy.mp3]  <img src=\"insurance policy.jpg\">  \n",
       "26           [sound:subsidy.mp3]           <img src=\"subsidy.jpg\">  \n",
       "27          [sound:downsize.mp3]          <img src=\"downsize.jpg\">  \n",
       "28         [sound:demanding.mp3]         <img src=\"demanding.jpg\">  \n",
       "29          [sound:drawback.mp3]          <img src=\"drawback.jpg\">  \n",
       "..                           ...                               ...  \n",
       "62           [sound:surplus.mp3]           <img src=\"surplus.jpg\">  \n",
       "63          [sound:morality.mp3]          <img src=\"morality.jpg\">  \n",
       "64        [sound:facilitate.mp3]        <img src=\"facilitate.jpg\">  \n",
       "65              [sound:dump.mp3]              <img src=\"dump.jpg\">  \n",
       "66           [sound:penalty.mp3]           <img src=\"penalty.jpg\">  \n",
       "67            [sound:edible.mp3]            <img src=\"edible.jpg\">  \n",
       "68            [sound:annual.mp3]            <img src=\"annual.jpg\">  \n",
       "69       [sound:legislation.mp3]       <img src=\"legislation.jpg\">  \n",
       "70            [sound:launch.mp3]            <img src=\"launch.jpg\">  \n",
       "71           [sound:worship.mp3]           <img src=\"worship.jpg\">  \n",
       "72          [sound:conflict.mp3]          <img src=\"conflict.jpg\">  \n",
       "73          [sound:apply to.mp3]          <img src=\"apply to.jpg\">  \n",
       "74             [sound:amuse.mp3]             <img src=\"amuse.jpg\">  \n",
       "75          [sound:retailer.mp3]          <img src=\"retailer.jpg\">  \n",
       "76         [sound:prejudice.mp3]         <img src=\"prejudice.jpg\">  \n",
       "77          [sound:ancestor.mp3]          <img src=\"ancestor.jpg\">  \n",
       "78          [sound:emphasis.mp3]          <img src=\"emphasis.jpg\">  \n",
       "79         [sound:ignorance.mp3]         <img src=\"ignorance.jpg\">  \n",
       "80             [sound:rival.mp3]             <img src=\"rival.jpg\">  \n",
       "81      [sound:dramatically.mp3]      <img src=\"dramatically.jpg\">  \n",
       "82         [sound:nutrition.mp3]         <img src=\"nutrition.jpg\">  \n",
       "83        [sound:pharmacist.mp3]        <img src=\"pharmacist.jpg\">  \n",
       "84          [sound:minority.mp3]          <img src=\"minority.jpg\">  \n",
       "85           [sound:nominee.mp3]           <img src=\"nominee.jpg\">  \n",
       "86          [sound:tendency.mp3]          <img src=\"tendency.jpg\">  \n",
       "87        [sound:stereotype.mp3]        <img src=\"stereotype.jpg\">  \n",
       "88         [sound:Hispanics.mp3]         <img src=\"Hispanics.jpg\">  \n",
       "89            [sound:biased.mp3]            <img src=\"biased.jpg\">  \n",
       "90           [sound:alcohol.mp3]           <img src=\"alcohol.jpg\">  \n",
       "91            [sound:ethnic.mp3]            <img src=\"ethnic.jpg\">  \n",
       "\n",
       "[92 rows x 5 columns]"
      ]
     },
     "execution_count": 8,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "#del dataframe[9]\n",
    "#del dataframe['a']\n",
    "dataframe"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 52,
   "metadata": {},
   "outputs": [],
   "source": [
    "dataframe.to_csv('word_list2.csv', encoding = 'gbk', sep = ',')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": []
  }
 ],
 "metadata": {
  "kernelspec": {
   "display_name": "Python 3",
   "language": "python",
   "name": "python3"
  },
  "language_info": {
   "codemirror_mode": {
    "name": "ipython",
    "version": 3
   },
   "file_extension": ".py",
   "mimetype": "text/x-python",
   "name": "python",
   "nbconvert_exporter": "python",
   "pygments_lexer": "ipython3",
   "version": "3.7.3"
  },
  "toc": {
   "base_numbering": 1,
   "nav_menu": {},
   "number_sections": true,
   "sideBar": true,
   "skip_h1_title": false,
   "title_cell": "Table of Contents",
   "title_sidebar": "Contents",
   "toc_cell": false,
   "toc_position": {},
   "toc_section_display": true,
   "toc_window_display": false
  },
  "varInspector": {
   "cols": {
    "lenName": 16,
    "lenType": 16,
    "lenVar": 40
   },
   "kernels_config": {
    "python": {
     "delete_cmd_postfix": "",
     "delete_cmd_prefix": "del ",
     "library": "var_list.py",
     "varRefreshCmd": "print(var_dic_list())"
    },
    "r": {
     "delete_cmd_postfix": ") ",
     "delete_cmd_prefix": "rm(",
     "library": "var_list.r",
     "varRefreshCmd": "cat(var_dic_list()) "
    }
   },
   "types_to_exclude": [
    "module",
    "function",
    "builtin_function_or_method",
    "instance",
    "_Feature"
   ],
   "window_display": false
  }
 },
 "nbformat": 4,
 "nbformat_minor": 2
}
